package com.zhan.easyexcelorder.repository;


import com.zhan.easyexcelorder.model.SysDepartment;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

public interface SysDepartmentRepository extends PagingAndSortingRepository<SysDepartment, Long>, JpaSpecificationExecutor<SysDepartment> {
    @Query(value = "select d from SysDepartment d WHERE d.fullDepartmentName = ?1")
    SysDepartment getSysDepartmentByName(String deptName);
}
